<?php

use Illuminate\Database\Migrations\Migration;

class CreateDetailuanvanTable extends Migration
{
    /**
    * Run the migrations.
    *
    * @return void
    */
    public function up()
    {
        Schema::create('de_tai_luan_van', function($table)
        {
            $table->engine='InnoDB';
            $table->increments('id')->unsigned();
            $table->string('ma_so_de_tai', 15)->unique();
            $table->string('ten_de_tai', 1024);
            $table->text('mo_ta_de_tai')->nullable()->default(null);
            $table->integer('so_luong_sv_th')->unsigned();
            $table->integer('id_hoc_ki_nien_khoa')->unsigned();
            $table->integer('id_bo_mon')->unsigned();
            $table->boolean('trang_thai');
        });
    }

    /**
    * reverse the migrations.
    *
    * @return void
    */
    public function down()
    {
        Schema::drop('de_tai_luan_van');
    }
}